Many-Dimensional Schema Modeling

نویسندگان

  • Thomas Feyer
  • Bernhard Thalheim
چکیده

Large database schemata can be drastically simplified if techniques of modular and structural modeling are used. Applications and thus schemata have an inner meta-structure. The explicit treatment of the inner structuring may be used during development of large database schemata and may ease the development to a large extent. It is surprising that dimensions and internal separations have not been considered yet also they are very natural and easy to capture. This paper develops an approach to explicit treatment of the inherent many-dimensional structuring on the basis of dimensions such as the kernel dimension, the association dimension, the log dimension, the meta-characterization dimension, and the lifespan dimension.

برای دانلود رایگان متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

An Analysis of Many-to-Many Relationships Between Fact and Dimension Tables in Dimensional Modeling

Star schema, which maintains one-to-many relationships between dimensions and a fact table, is widely accepted as the most viable data representation for dimensional analysis. Realworld DW schema, however, frequently includes many-to-many relationships between a dimension and a fact table. Having those relationships in a dimensional model causes several difficult issues, such as losing the simp...

متن کامل

The Comparison of Anchor and Star Schema from a Query Performance Perspective

Today's business environment requires that companies have access to highly relevant information in a matter of seconds. Modern Business Intelligence tools rely on data structured mostly in traditional dimensional database schemas, typically represented by star schemas. Dimensional modeling is already recognized as a leading industry standard in the field of data warehousing although several dra...

متن کامل

Event-Entity-Relationship Modeling In Data Warehouse Environments1

We use the event-entity-relationship model (EVER) to illustrate the use of entity-based modeling languages for conceptual schema design in data warehouse environments. EVER is a general-purpose information modeling language that supports the specification of both general schema structures and multi-dimensional schemes that are customized to serve specific information needs. EVER is based on an ...

متن کامل

SCIT: A Schema Change Interpretation Tool for Dynamic-Schema Data Warehouses

Data Warehouses (DW) have to continuously adapt to evolving business requirements, which implies structure modification (schema changes) and data migration requirements in the system design. However, it is challenging for designers to control the performance and cost overhead of different schema change implementations. In this paper, we demonstrate SCIT, a tool for DW designers to test and impl...

متن کامل

A Three-dimensional Numerical Modeling of Contaminant Dispersion from Arvand Rood River into the Persian Gulf

The Persian Gulf is an important economic and geo-political region. Owing to its oil and gas resources, it is one of the busiest waterways in the world. There are many operating oil wells in the northern part of the Persian Gulf . As a result, the risk of contaminant dispersion is high. The deliberate discharge of 6.3 million barrels of crude oil during the 1991 war against Kuwait in this regio...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 2002